---
sidebar_label: Simple object queries
sidebar_position: 1
description: Make simple object queries on MS SQL Server in Hasura
keywords:
  - hasura
  - docs
  - ms sql server
  - object query
---

import GraphiQLIDE from "@site/src/components/GraphiQLIDE";

# MS SQL Server: Simple Object Queries

## Introduction

You can fetch a single node or multiple nodes of the same type using a
simple object query.

## Fetch list of objects

**Example:** Fetch a list of authors:

<GraphiQLIDE
  query={`query {
  authors {
    id
    name
  }
}`}
  response={`{
  "data": {
    "authors": [
      {
        "id": 1,
        "name": "Justin"
      },
      {
        "id": 2,
        "name": "Beltran"
      },
      {
        "id": 3,
        "name": "Sidney"
      },
      {
        "id": 4,
        "name": "Anjela"
      }
    ]
  }
}`}
/>

<!--


.. TODO: DBCOMPATIBILITY
  Fetch an object using its primary key

  -------------------------------------
  **Example:** Fetch an author using their primary key:
  .. graphiql::
    :view_only:
    :query:
      query {
        authors_by_pk(id: 1) {
          id
          name
        }
      }
    :response:
      {
        "data": {
          "authors_by_pk": {
            "id": 1,
            "name": "Justin"
          }
        }
      }

  Fetch value from JSON/JSONB column at particular path
  -----------------------------------------------------
  **Example:** Fetch the city and phone number of an author from their JSONB
  address column:

  .. graphiql::
    :view_only:
    :query:
      query {
        authors_by_pk(id: 1) {
          id
          name
          address
          city: address(path: "$.city")
          phone: address(path: "$.phone_numbers.[0]")
        }
      }
    :response:
      {
        "data": {
          "authors_by_pk": {
            "id": 1,
            "name": "Justin",
            "address": {
              "city": "Bengaluru",
              "phone_numbers": [9090909090, 8080808080]
            },
            "city": "Bengaluru",
            "phone": 9090909090
          }
        }
      }

-->

See the [API reference](/api-reference/graphql-api/query.mdx#simpleobject) for more details.
